import xlrd


class case_data:
    def get_data(self,file,index):
        global book
        book = xlrd.open_workbook(filename=file)
        st = book.sheet_by_index(index)
        lengh1 = len(st.col_values(0)[:])
        data = []
        for i in range(1, lengh1):
            data.append(st.row_values(i)[:])
        return data